﻿CREATE TABLE [dbo].[Department] (
    [Id]          UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [Name]        NVARCHAR (250)   NOT NULL,
    [ShortName]   NVARCHAR (50)    NULL,
    [Description] NTEXT            NULL
);

